package com.ztesoft.web.baseconfig.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmSrcTableArg {
    private String pk_name = "SOURCE_DATA_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmSrcTableCriteria> oredCriteria;

    public DmSrcTableArg() {
        oredCriteria = new ArrayList<DmSrcTableCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmSrcTableCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmSrcTableCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmSrcTableCriteria or() {
    	DmSrcTableCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmSrcTableCriteria createCriteria() {
    	DmSrcTableCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmSrcTableCriteria createCriteriaInternal() {
    	DmSrcTableCriteria criteria = new DmSrcTableCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmSrcTableCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmSrcTableCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmSrcTableCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmSrcTableCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmSrcTableCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmSrcTableCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmSrcTableCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmSrcTableCriterion(condition, value1, value2));
        }

        public DmSrcTableCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andSourceDataIdIsNull() {
            addCriterion("SOURCE_DATA_ID is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdIsNotNull() {
            addCriterion("SOURCE_DATA_ID is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID =", value, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdNotEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <>", value, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdGreaterThan(Integer value) {
            addCriterion("SOURCE_DATA_ID >", value, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID >=", value, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdLessThan(Integer value) {
            addCriterion("SOURCE_DATA_ID <", value, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <=", value, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdNotLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdNotLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdNotRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID  in ", values, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdNotIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID not in ", values, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID between ", value1, value2, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSourceDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID not between ", value1, value2, "SOURCE_DATA_ID");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andSeqNbrIsNull() {
            addCriterion("SEQ_NBR is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrIsNotNull() {
            addCriterion("SEQ_NBR is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrEqualTo(Integer value) {
            addCriterion("SEQ_NBR =", value, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrNotEqualTo(Integer value) {
            addCriterion("SEQ_NBR <>", value, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrGreaterThan(Integer value) {
            addCriterion("SEQ_NBR >", value, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrGreaterThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR >=", value, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrLessThan(Integer value) {
            addCriterion("SEQ_NBR <", value, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrLessThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR <=", value, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrNotLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrLeftLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrNotLeftLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrRightLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrNotRightLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrIn(List<Integer> values) {
            addCriterion("SEQ_NBR  in ", values, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrNotIn(List<Integer> values) {
            addCriterion("SEQ_NBR not in ", values, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR between ", value1, value2, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSeqNbrNotBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR not between ", value1, value2, "SEQ_NBR");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andDbLinkIdIsNull() {
            addCriterion("db_link_id is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdIsNotNull() {
            addCriterion("db_link_id is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdEqualTo(Integer value) {
            addCriterion("db_link_id =", value, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdNotEqualTo(Integer value) {
            addCriterion("db_link_id <>", value, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdGreaterThan(Integer value) {
            addCriterion("db_link_id >", value, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("db_link_id >=", value, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdLessThan(Integer value) {
            addCriterion("db_link_id <", value, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdLessThanOrEqualTo(Integer value) {
            addCriterion("db_link_id <=", value, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdLike(Integer value) {
            addCriterion("db_link_id like ", value, "db_link_id", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdNotLike(Integer value) {
            addCriterion("db_link_id  not like ", value, "db_link_id", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdLeftLike(Integer value) {
            addCriterion("db_link_id like ", value, "db_link_id", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdNotLeftLike(Integer value) {
            addCriterion("db_link_id  not like ", value, "db_link_id", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdRightLike(Integer value) {
            addCriterion("db_link_id like ", value, "db_link_id", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdNotRightLike(Integer value) {
            addCriterion("db_link_id  not like ", value, "db_link_id", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdIn(List<Integer> values) {
            addCriterion("db_link_id  in ", values, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdNotIn(List<Integer> values) {
            addCriterion("db_link_id not in ", values, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdBetween(Integer value1, Integer value2) {
            addCriterion("db_link_id between ", value1, value2, "db_link_id");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbLinkIdNotBetween(Integer value1, Integer value2) {
            addCriterion("db_link_id not between ", value1, value2, "db_link_id");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andDbUserNameIsNull() {
            addCriterion("db_user_name is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameIsNotNull() {
            addCriterion("db_user_name is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameEqualTo(String value) {
            addCriterion("db_user_name =", value, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameNotEqualTo(String value) {
            addCriterion("db_user_name <>", value, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameGreaterThan(String value) {
            addCriterion("db_user_name >", value, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("db_user_name >=", value, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameLessThan(String value) {
            addCriterion("db_user_name <", value, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameLessThanOrEqualTo(String value) {
            addCriterion("db_user_name <=", value, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameLike(String value) {
            addCriterion("db_user_name like ", value, "db_user_name", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameNotLike(String value) {
            addCriterion("db_user_name  not like ", value, "db_user_name", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameLeftLike(String value) {
            addCriterion("db_user_name like ", value, "db_user_name", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameNotLeftLike(String value) {
            addCriterion("db_user_name  not like ", value, "db_user_name", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameRightLike(String value) {
            addCriterion("db_user_name like ", value, "db_user_name", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameNotRightLike(String value) {
            addCriterion("db_user_name  not like ", value, "db_user_name", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameIn(List<String> values) {
            addCriterion("db_user_name  in ", values, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameNotIn(List<String> values) {
            addCriterion("db_user_name not in ", values, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameBetween(String value1, String value2) {
            addCriterion("db_user_name between ", value1, value2, "db_user_name");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andDbUserNameNotBetween(String value1, String value2) {
            addCriterion("db_user_name not between ", value1, value2, "db_user_name");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andTableNameIsNull() {
            addCriterion("TABLE_NAME is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameIsNotNull() {
            addCriterion("TABLE_NAME is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameEqualTo(String value) {
            addCriterion("TABLE_NAME =", value, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameNotEqualTo(String value) {
            addCriterion("TABLE_NAME <>", value, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameGreaterThan(String value) {
            addCriterion("TABLE_NAME >", value, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameGreaterThanOrEqualTo(String value) {
            addCriterion("TABLE_NAME >=", value, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameLessThan(String value) {
            addCriterion("TABLE_NAME <", value, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameLessThanOrEqualTo(String value) {
            addCriterion("TABLE_NAME <=", value, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameNotLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameLeftLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameNotLeftLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameRightLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameNotRightLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameIn(List<String> values) {
            addCriterion("TABLE_NAME  in ", values, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameNotIn(List<String> values) {
            addCriterion("TABLE_NAME not in ", values, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameBetween(String value1, String value2) {
            addCriterion("TABLE_NAME between ", value1, value2, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andTableNameNotBetween(String value1, String value2) {
            addCriterion("TABLE_NAME not between ", value1, value2, "TABLE_NAME");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andMainDataIdIsNull() {
            addCriterion("MAIN_DATA_ID is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdIsNotNull() {
            addCriterion("MAIN_DATA_ID is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdEqualTo(Integer value) {
            addCriterion("MAIN_DATA_ID =", value, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdNotEqualTo(Integer value) {
            addCriterion("MAIN_DATA_ID <>", value, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdGreaterThan(Integer value) {
            addCriterion("MAIN_DATA_ID >", value, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("MAIN_DATA_ID >=", value, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdLessThan(Integer value) {
            addCriterion("MAIN_DATA_ID <", value, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("MAIN_DATA_ID <=", value, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdLike(Integer value) {
            addCriterion("MAIN_DATA_ID like ", value, "MAIN_DATA_ID", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdNotLike(Integer value) {
            addCriterion("MAIN_DATA_ID  not like ", value, "MAIN_DATA_ID", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdLeftLike(Integer value) {
            addCriterion("MAIN_DATA_ID like ", value, "MAIN_DATA_ID", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdNotLeftLike(Integer value) {
            addCriterion("MAIN_DATA_ID  not like ", value, "MAIN_DATA_ID", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdRightLike(Integer value) {
            addCriterion("MAIN_DATA_ID like ", value, "MAIN_DATA_ID", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdNotRightLike(Integer value) {
            addCriterion("MAIN_DATA_ID  not like ", value, "MAIN_DATA_ID", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdIn(List<Integer> values) {
            addCriterion("MAIN_DATA_ID  in ", values, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdNotIn(List<Integer> values) {
            addCriterion("MAIN_DATA_ID not in ", values, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdBetween(Integer value1, Integer value2) {
            addCriterion("MAIN_DATA_ID between ", value1, value2, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andMainDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("MAIN_DATA_ID not between ", value1, value2, "MAIN_DATA_ID");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andSubFlagIsNull() {
            addCriterion("SUB_FLAG is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagIsNotNull() {
            addCriterion("SUB_FLAG is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagEqualTo(String value) {
            addCriterion("SUB_FLAG =", value, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagNotEqualTo(String value) {
            addCriterion("SUB_FLAG <>", value, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagGreaterThan(String value) {
            addCriterion("SUB_FLAG >", value, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_FLAG >=", value, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagLessThan(String value) {
            addCriterion("SUB_FLAG <", value, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagLessThanOrEqualTo(String value) {
            addCriterion("SUB_FLAG <=", value, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagLike(String value) {
            addCriterion("SUB_FLAG like ", value, "SUB_FLAG", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagNotLike(String value) {
            addCriterion("SUB_FLAG  not like ", value, "SUB_FLAG", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagLeftLike(String value) {
            addCriterion("SUB_FLAG like ", value, "SUB_FLAG", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagNotLeftLike(String value) {
            addCriterion("SUB_FLAG  not like ", value, "SUB_FLAG", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagRightLike(String value) {
            addCriterion("SUB_FLAG like ", value, "SUB_FLAG", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagNotRightLike(String value) {
            addCriterion("SUB_FLAG  not like ", value, "SUB_FLAG", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagIn(List<String> values) {
            addCriterion("SUB_FLAG  in ", values, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagNotIn(List<String> values) {
            addCriterion("SUB_FLAG not in ", values, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagBetween(String value1, String value2) {
            addCriterion("SUB_FLAG between ", value1, value2, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSubFlagNotBetween(String value1, String value2) {
            addCriterion("SUB_FLAG not between ", value1, value2, "SUB_FLAG");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andArchiveModeIsNull() {
            addCriterion("ARCHIVE_MODE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeIsNotNull() {
            addCriterion("ARCHIVE_MODE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeEqualTo(Integer value) {
            addCriterion("ARCHIVE_MODE =", value, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeNotEqualTo(Integer value) {
            addCriterion("ARCHIVE_MODE <>", value, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeGreaterThan(Integer value) {
            addCriterion("ARCHIVE_MODE >", value, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ARCHIVE_MODE >=", value, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeLessThan(Integer value) {
            addCriterion("ARCHIVE_MODE <", value, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeLessThanOrEqualTo(Integer value) {
            addCriterion("ARCHIVE_MODE <=", value, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeLike(Integer value) {
            addCriterion("ARCHIVE_MODE like ", value, "ARCHIVE_MODE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeNotLike(Integer value) {
            addCriterion("ARCHIVE_MODE  not like ", value, "ARCHIVE_MODE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeLeftLike(Integer value) {
            addCriterion("ARCHIVE_MODE like ", value, "ARCHIVE_MODE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeNotLeftLike(Integer value) {
            addCriterion("ARCHIVE_MODE  not like ", value, "ARCHIVE_MODE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeRightLike(Integer value) {
            addCriterion("ARCHIVE_MODE like ", value, "ARCHIVE_MODE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeNotRightLike(Integer value) {
            addCriterion("ARCHIVE_MODE  not like ", value, "ARCHIVE_MODE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeIn(List<Integer> values) {
            addCriterion("ARCHIVE_MODE  in ", values, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeNotIn(List<Integer> values) {
            addCriterion("ARCHIVE_MODE not in ", values, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeBetween(Integer value1, Integer value2) {
            addCriterion("ARCHIVE_MODE between ", value1, value2, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveModeNotBetween(Integer value1, Integer value2) {
            addCriterion("ARCHIVE_MODE not between ", value1, value2, "ARCHIVE_MODE");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andArchiveTypeIsNull() {
            addCriterion("ARCHIVE_TYPE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeIsNotNull() {
            addCriterion("ARCHIVE_TYPE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeEqualTo(Integer value) {
            addCriterion("ARCHIVE_TYPE =", value, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeNotEqualTo(Integer value) {
            addCriterion("ARCHIVE_TYPE <>", value, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeGreaterThan(Integer value) {
            addCriterion("ARCHIVE_TYPE >", value, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ARCHIVE_TYPE >=", value, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeLessThan(Integer value) {
            addCriterion("ARCHIVE_TYPE <", value, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeLessThanOrEqualTo(Integer value) {
            addCriterion("ARCHIVE_TYPE <=", value, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeLike(Integer value) {
            addCriterion("ARCHIVE_TYPE like ", value, "ARCHIVE_TYPE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeNotLike(Integer value) {
            addCriterion("ARCHIVE_TYPE  not like ", value, "ARCHIVE_TYPE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeLeftLike(Integer value) {
            addCriterion("ARCHIVE_TYPE like ", value, "ARCHIVE_TYPE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeNotLeftLike(Integer value) {
            addCriterion("ARCHIVE_TYPE  not like ", value, "ARCHIVE_TYPE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeRightLike(Integer value) {
            addCriterion("ARCHIVE_TYPE like ", value, "ARCHIVE_TYPE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeNotRightLike(Integer value) {
            addCriterion("ARCHIVE_TYPE  not like ", value, "ARCHIVE_TYPE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeIn(List<Integer> values) {
            addCriterion("ARCHIVE_TYPE  in ", values, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeNotIn(List<Integer> values) {
            addCriterion("ARCHIVE_TYPE not in ", values, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeBetween(Integer value1, Integer value2) {
            addCriterion("ARCHIVE_TYPE between ", value1, value2, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andArchiveTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ARCHIVE_TYPE not between ", value1, value2, "ARCHIVE_TYPE");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andReverseFlagIsNull() {
            addCriterion("REVERSE_FLAG is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagIsNotNull() {
            addCriterion("REVERSE_FLAG is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagEqualTo(String value) {
            addCriterion("REVERSE_FLAG =", value, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagNotEqualTo(String value) {
            addCriterion("REVERSE_FLAG <>", value, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagGreaterThan(String value) {
            addCriterion("REVERSE_FLAG >", value, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagGreaterThanOrEqualTo(String value) {
            addCriterion("REVERSE_FLAG >=", value, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagLessThan(String value) {
            addCriterion("REVERSE_FLAG <", value, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagLessThanOrEqualTo(String value) {
            addCriterion("REVERSE_FLAG <=", value, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagLike(String value) {
            addCriterion("REVERSE_FLAG like ", value, "REVERSE_FLAG", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagNotLike(String value) {
            addCriterion("REVERSE_FLAG  not like ", value, "REVERSE_FLAG", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagLeftLike(String value) {
            addCriterion("REVERSE_FLAG like ", value, "REVERSE_FLAG", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagNotLeftLike(String value) {
            addCriterion("REVERSE_FLAG  not like ", value, "REVERSE_FLAG", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagRightLike(String value) {
            addCriterion("REVERSE_FLAG like ", value, "REVERSE_FLAG", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagNotRightLike(String value) {
            addCriterion("REVERSE_FLAG  not like ", value, "REVERSE_FLAG", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagIn(List<String> values) {
            addCriterion("REVERSE_FLAG  in ", values, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagNotIn(List<String> values) {
            addCriterion("REVERSE_FLAG not in ", values, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagBetween(String value1, String value2) {
            addCriterion("REVERSE_FLAG between ", value1, value2, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andReverseFlagNotBetween(String value1, String value2) {
            addCriterion("REVERSE_FLAG not between ", value1, value2, "REVERSE_FLAG");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andOneRecordSizeIsNull() {
            addCriterion("ONE_RECORD_SIZE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeIsNotNull() {
            addCriterion("ONE_RECORD_SIZE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE =", value, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeNotEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE <>", value, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeGreaterThan(Integer value) {
            addCriterion("ONE_RECORD_SIZE >", value, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE >=", value, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeLessThan(Integer value) {
            addCriterion("ONE_RECORD_SIZE <", value, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeLessThanOrEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE <=", value, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE like ", value, "ONE_RECORD_SIZE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeNotLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE  not like ", value, "ONE_RECORD_SIZE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeLeftLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE like ", value, "ONE_RECORD_SIZE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeNotLeftLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE  not like ", value, "ONE_RECORD_SIZE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeRightLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE like ", value, "ONE_RECORD_SIZE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeNotRightLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE  not like ", value, "ONE_RECORD_SIZE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeIn(List<Integer> values) {
            addCriterion("ONE_RECORD_SIZE  in ", values, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeNotIn(List<Integer> values) {
            addCriterion("ONE_RECORD_SIZE not in ", values, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeBetween(Integer value1, Integer value2) {
            addCriterion("ONE_RECORD_SIZE between ", value1, value2, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOneRecordSizeNotBetween(Integer value1, Integer value2) {
            addCriterion("ONE_RECORD_SIZE not between ", value1, value2, "ONE_RECORD_SIZE");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andKeyColumnIsNull() {
            addCriterion("KEY_COLUMN is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnIsNotNull() {
            addCriterion("KEY_COLUMN is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnEqualTo(String value) {
            addCriterion("KEY_COLUMN =", value, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnNotEqualTo(String value) {
            addCriterion("KEY_COLUMN <>", value, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnGreaterThan(String value) {
            addCriterion("KEY_COLUMN >", value, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnGreaterThanOrEqualTo(String value) {
            addCriterion("KEY_COLUMN >=", value, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnLessThan(String value) {
            addCriterion("KEY_COLUMN <", value, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnLessThanOrEqualTo(String value) {
            addCriterion("KEY_COLUMN <=", value, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnLike(String value) {
            addCriterion("KEY_COLUMN like ", value, "KEY_COLUMN", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnNotLike(String value) {
            addCriterion("KEY_COLUMN  not like ", value, "KEY_COLUMN", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnLeftLike(String value) {
            addCriterion("KEY_COLUMN like ", value, "KEY_COLUMN", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnNotLeftLike(String value) {
            addCriterion("KEY_COLUMN  not like ", value, "KEY_COLUMN", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnRightLike(String value) {
            addCriterion("KEY_COLUMN like ", value, "KEY_COLUMN", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnNotRightLike(String value) {
            addCriterion("KEY_COLUMN  not like ", value, "KEY_COLUMN", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnIn(List<String> values) {
            addCriterion("KEY_COLUMN  in ", values, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnNotIn(List<String> values) {
            addCriterion("KEY_COLUMN not in ", values, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnBetween(String value1, String value2) {
            addCriterion("KEY_COLUMN between ", value1, value2, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andKeyColumnNotBetween(String value1, String value2) {
            addCriterion("KEY_COLUMN not between ", value1, value2, "KEY_COLUMN");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andOffsetTypeIsNull() {
            addCriterion("OFFSET_TYPE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeIsNotNull() {
            addCriterion("OFFSET_TYPE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeEqualTo(String value) {
            addCriterion("OFFSET_TYPE =", value, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeNotEqualTo(String value) {
            addCriterion("OFFSET_TYPE <>", value, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeGreaterThan(String value) {
            addCriterion("OFFSET_TYPE >", value, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeGreaterThanOrEqualTo(String value) {
            addCriterion("OFFSET_TYPE >=", value, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeLessThan(String value) {
            addCriterion("OFFSET_TYPE <", value, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeLessThanOrEqualTo(String value) {
            addCriterion("OFFSET_TYPE <=", value, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeLike(String value) {
            addCriterion("OFFSET_TYPE like ", value, "OFFSET_TYPE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeNotLike(String value) {
            addCriterion("OFFSET_TYPE  not like ", value, "OFFSET_TYPE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeLeftLike(String value) {
            addCriterion("OFFSET_TYPE like ", value, "OFFSET_TYPE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeNotLeftLike(String value) {
            addCriterion("OFFSET_TYPE  not like ", value, "OFFSET_TYPE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeRightLike(String value) {
            addCriterion("OFFSET_TYPE like ", value, "OFFSET_TYPE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeNotRightLike(String value) {
            addCriterion("OFFSET_TYPE  not like ", value, "OFFSET_TYPE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeIn(List<String> values) {
            addCriterion("OFFSET_TYPE  in ", values, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeNotIn(List<String> values) {
            addCriterion("OFFSET_TYPE not in ", values, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeBetween(String value1, String value2) {
            addCriterion("OFFSET_TYPE between ", value1, value2, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andOffsetTypeNotBetween(String value1, String value2) {
            addCriterion("OFFSET_TYPE not between ", value1, value2, "OFFSET_TYPE");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andUpperOffsetIsNull() {
            addCriterion("UPPER_OFFSET is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetIsNotNull() {
            addCriterion("UPPER_OFFSET is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetEqualTo(Integer value) {
            addCriterion("UPPER_OFFSET =", value, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetNotEqualTo(Integer value) {
            addCriterion("UPPER_OFFSET <>", value, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetGreaterThan(Integer value) {
            addCriterion("UPPER_OFFSET >", value, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetGreaterThanOrEqualTo(Integer value) {
            addCriterion("UPPER_OFFSET >=", value, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetLessThan(Integer value) {
            addCriterion("UPPER_OFFSET <", value, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetLessThanOrEqualTo(Integer value) {
            addCriterion("UPPER_OFFSET <=", value, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetLike(Integer value) {
            addCriterion("UPPER_OFFSET like ", value, "UPPER_OFFSET", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetNotLike(Integer value) {
            addCriterion("UPPER_OFFSET  not like ", value, "UPPER_OFFSET", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetLeftLike(Integer value) {
            addCriterion("UPPER_OFFSET like ", value, "UPPER_OFFSET", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetNotLeftLike(Integer value) {
            addCriterion("UPPER_OFFSET  not like ", value, "UPPER_OFFSET", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetRightLike(Integer value) {
            addCriterion("UPPER_OFFSET like ", value, "UPPER_OFFSET", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetNotRightLike(Integer value) {
            addCriterion("UPPER_OFFSET  not like ", value, "UPPER_OFFSET", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetIn(List<Integer> values) {
            addCriterion("UPPER_OFFSET  in ", values, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetNotIn(List<Integer> values) {
            addCriterion("UPPER_OFFSET not in ", values, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetBetween(Integer value1, Integer value2) {
            addCriterion("UPPER_OFFSET between ", value1, value2, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andUpperOffsetNotBetween(Integer value1, Integer value2) {
            addCriterion("UPPER_OFFSET not between ", value1, value2, "UPPER_OFFSET");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andLowerOffsetIsNull() {
            addCriterion("LOWER_OFFSET is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetIsNotNull() {
            addCriterion("LOWER_OFFSET is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetEqualTo(Integer value) {
            addCriterion("LOWER_OFFSET =", value, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetNotEqualTo(Integer value) {
            addCriterion("LOWER_OFFSET <>", value, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetGreaterThan(Integer value) {
            addCriterion("LOWER_OFFSET >", value, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetGreaterThanOrEqualTo(Integer value) {
            addCriterion("LOWER_OFFSET >=", value, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetLessThan(Integer value) {
            addCriterion("LOWER_OFFSET <", value, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetLessThanOrEqualTo(Integer value) {
            addCriterion("LOWER_OFFSET <=", value, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetLike(Integer value) {
            addCriterion("LOWER_OFFSET like ", value, "LOWER_OFFSET", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetNotLike(Integer value) {
            addCriterion("LOWER_OFFSET  not like ", value, "LOWER_OFFSET", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetLeftLike(Integer value) {
            addCriterion("LOWER_OFFSET like ", value, "LOWER_OFFSET", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetNotLeftLike(Integer value) {
            addCriterion("LOWER_OFFSET  not like ", value, "LOWER_OFFSET", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetRightLike(Integer value) {
            addCriterion("LOWER_OFFSET like ", value, "LOWER_OFFSET", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetNotRightLike(Integer value) {
            addCriterion("LOWER_OFFSET  not like ", value, "LOWER_OFFSET", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetIn(List<Integer> values) {
            addCriterion("LOWER_OFFSET  in ", values, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetNotIn(List<Integer> values) {
            addCriterion("LOWER_OFFSET not in ", values, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetBetween(Integer value1, Integer value2) {
            addCriterion("LOWER_OFFSET between ", value1, value2, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andLowerOffsetNotBetween(Integer value1, Integer value2) {
            addCriterion("LOWER_OFFSET not between ", value1, value2, "LOWER_OFFSET");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andSelectConditionIsNull() {
            addCriterion("SELECT_CONDITION is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionIsNotNull() {
            addCriterion("SELECT_CONDITION is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionEqualTo(String value) {
            addCriterion("SELECT_CONDITION =", value, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionNotEqualTo(String value) {
            addCriterion("SELECT_CONDITION <>", value, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionGreaterThan(String value) {
            addCriterion("SELECT_CONDITION >", value, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionGreaterThanOrEqualTo(String value) {
            addCriterion("SELECT_CONDITION >=", value, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionLessThan(String value) {
            addCriterion("SELECT_CONDITION <", value, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionLessThanOrEqualTo(String value) {
            addCriterion("SELECT_CONDITION <=", value, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionLike(String value) {
            addCriterion("SELECT_CONDITION like ", value, "SELECT_CONDITION", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionNotLike(String value) {
            addCriterion("SELECT_CONDITION  not like ", value, "SELECT_CONDITION", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionLeftLike(String value) {
            addCriterion("SELECT_CONDITION like ", value, "SELECT_CONDITION", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionNotLeftLike(String value) {
            addCriterion("SELECT_CONDITION  not like ", value, "SELECT_CONDITION", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionRightLike(String value) {
            addCriterion("SELECT_CONDITION like ", value, "SELECT_CONDITION", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionNotRightLike(String value) {
            addCriterion("SELECT_CONDITION  not like ", value, "SELECT_CONDITION", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionIn(List<String> values) {
            addCriterion("SELECT_CONDITION  in ", values, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionNotIn(List<String> values) {
            addCriterion("SELECT_CONDITION not in ", values, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionBetween(String value1, String value2) {
            addCriterion("SELECT_CONDITION between ", value1, value2, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andSelectConditionNotBetween(String value1, String value2) {
            addCriterion("SELECT_CONDITION not between ", value1, value2, "SELECT_CONDITION");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andStaffIdIsNull() {
            addCriterion("STAFF_ID is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdIsNotNull() {
            addCriterion("STAFF_ID is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdEqualTo(Integer value) {
            addCriterion("STAFF_ID =", value, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("STAFF_ID <>", value, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdGreaterThan(Integer value) {
            addCriterion("STAFF_ID >", value, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID >=", value, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdLessThan(Integer value) {
            addCriterion("STAFF_ID <", value, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID <=", value, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdNotLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdLeftLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdNotLeftLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdRightLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdNotRightLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdIn(List<Integer> values) {
            addCriterion("STAFF_ID  in ", values, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("STAFF_ID not in ", values, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID between ", value1, value2, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID not between ", value1, value2, "STAFF_ID");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmSrcTableCriteria) this;
        }
        public DmSrcTableCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateLeftLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateRightLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateNotRightLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

        public DmSrcTableCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (DmSrcTableCriteria) this;
        }

    }

    public static class DmSrcTableCriteria extends GeneratedCriteria {

        protected DmSrcTableCriteria() {
            super();
        }
    }

    public static class DmSrcTableCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmSrcTableCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmSrcTableCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmSrcTableCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmSrcTableCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmSrcTableCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmSrcTableCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}